You are here:

Release Task Weekly Snapshot

Release Task Weekly Snapshot iCube enables you to create ad hoc reports that help you analyze your release cycles as and when tasks associated with the release progress. Using this dossier, you can chart a week-wise release task progress report. You can view a snapshot of historical data from the past six months.

Attributes

Expand this link to view the list of attributes available as part of the Release Task Weekly Snapshot iCube:

Attributes	Description
Calendar Week	Gregorian calendar week displaying the week number. For example, W21, W22.
Lagging Count of Weeks Snapshot	Count of number of weeks since the first data record till current week (where current week is taken as 0)
Release ID	Unique ID of the release
Release Name	Name of the release
Release Phase Name	Name of the release phase
Release Task Flag Status	Flag to indicate if the release task needs attention
Release Task Name	The title of the release task
Release Task Projected Planned End Date	The date on which the Release Task is scheduled to end and is calculated based on the specified task duration. Note: This attribute is supported for Digital.ai Release source system only.
Release Task Projected Planned Start Date	The date on which the Release Task is scheduled to start and is calculated based on the specified task duration. Note: This attribute is supported for Digital.ai Release source system only.
Release Task Status	Status of the task in a release
Release Task Weekly Snapshot Dim Key	Key column (internal) associated with a Release Task Weekly Snapshot

Metrics

Expand this link to view the list of metrics available as part of the Release Task Weekly Snapshot iCube:

Metric Name	Description	Formula	Expected Value
Avg Release Task Actual Duration (Days)	Average of the duration of all tasks where duration is the time between Actual Start and Actual End date of the task	NullToZero(([Release Task Actual Duration - Snapshot] / (86400 * [No Release Tasks - Snapshot])))	>=0
Avg Release Task Planned Duration (Days)	Average of the duration of all tasks where duration is the time between Planned Start Date and Planned End Date of the task	NullToZero(([Release Task Planned Duration - Snapshot] / (86400 * [No Release Tasks - Snapshot])))	>=0
Avg Release Task Projected Planned Duration (Days)	Average projected duration (in days) that is planned for the Release Task. The metric considers projected dates that are determined based on the specified task duration. Note: This metric is supported for Digital.ai Release source system only.	[Release Task Projected Planned Duration - Snapshot] / (86400 * [No of Running Release Tasks - Snapshot])	>=0
Avg Release Task Projected Schedule Variance (Days)	Average variance (in days) in schedule across release tasks, calculated as the difference between the projected planned duration and actual duration of the release tasks. The metric considers projected dates that are determined based on the specified task duration. Note: This metric is supported for Digital.ai Release source system only.	[Release Task Projected Schedule Variance (Days) - Snapshot] / [No of Running Release Tasks - Snapshot]	>=0
No of Release Tasks	Count of all tasks for a specific period of time	Count([No Release Tasks - Snapshot])	>=0
No of Retries for Failed Tasks	Count of retries done by the user for failed tasks till it is successful or is skipped	Sum([No of Retries for Failed Tasks - Snapshot])	>=0